create table seat(id int identity not null,student varchar(20))
go
set nocount on
insert into seat values('abbot')
insert into seat values('doris')
insert into seat values('emereson')
insert into seat values('green')
insert into seat values('jeames')
go


select id,student=case 
					when id=1 then (select student from seat where id=2)  
					when id=2 then (select student from seat where id=1)
					when id=3 then (select student from seat where id=4)
					when id=4 then (select student from seat where id=3)
					when id=5 then (select student from seat where id=5)
				end
from seat